Model Table ACCOUNT
This model dimension represents financial accounts and is based
on the IFS Cloud dimension DIM_ACCOUNT. Most models that refer to this dimension
will have the attributes and hierarchies as described below. One exception is the General Ledger model that also contains structure information related to:
- Balance Sheet Structure
- Income Statement Structure
Natural parent is company, i.e. each company has its on set of accounts.
Attributes
| Attribute |
Description (where applicable) |
| Account | Built as CODE + ' - ' + DESCRIPTION |
| Account Code | Represents the CODE of the dimension, i.e. account |
| Account Desc | Represents the description of the Account |
| Account Group | Represents COMPANY + ' - ' + ACCOUNT_GROUP + ' - ' + ACCOUNT_GROUP_DESC |
| Account Group Code | Represents the account group code |
| Account Group Desc | Represents the account group description |
| Account Type | Represents the COMPANY + ' - ' + ACCOUT_TYPE + ' - ' + ACCOUNT_TYPE_DESC |
| Account Type Code | Represents the account type code |
| Account Type Desc | Represents the account type description |
| Bs Structure ID | Identity of the Balance Sheet structure |
| Bs Value Description | Name of a node or a leaf in the Balance Sheet structure |
| Company | Represents the natural parent COMPANY |
| Company - Account | Built as COMPANY + ' - ' CODE + ' - ' + DESCRIPTION |
| Group Account | Represents the Group Account |
| Is Structure ID | Income Statement structure |
| Is Value Description | Name of a node or a leaf in the Income Statement structure |
| Logical Account Type | Represents the Logical Account Type |
| Logical Account Type Code | Represents the Logical Account Type Code |
| Statement Type | Represents Statement Type Description |
| Statement Type Code | Represents Statement Type Code |
| Hierarchy |
Level |
| BsHy | |
| BSL01 |
| BSL02 |
| BSL03 |
| BSL04 |
| BSL05 |
| BSL06 |
| BSL07 |
| BSL08 |
| BSL09 |
| BSL10 |
| IsHy | |
| ISL01 |
| ISL02 |
| ISL03 |
| ISL04 |
| ISL05 |
| ISL06 |
| ISL07 |
| ISL08 |
| ISL09 |
| ISL10 |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table |
DW Source view (SQL Server) |
BI Access View |
Referenced Information Source |
Recommended Access Type |
| ACCOUNT | DIM_ACCOUNT_FINANCIALS_TM | DIM_ACCOUNT_BI | DIM_ACCOUNT | On Line |